package DBLayer;

import Model.Supplier;
import java.util.ArrayList;

/**
 *
 * @author Administrator
 */
public interface DbInterfaceSupplier {
	//get all customers
    public ArrayList<Supplier> getAllSuppliers(String wClause);
    //find Supplier by unique value
    public Supplier searchById(String id);
    public Supplier searchByPhone(String phone);
    public Supplier searchByEmail(String email);
    //insert new Supplier
    public int insertSupplier(Supplier sup);
    //update informations for one Supplier
    public int updateSupplier(Supplier sup);
    //delete Supplier by Id
    public int deleteSupplier(String phone);
}
